CREATING LINE AND CLUSTRED CHART 1
13
Create line and clustered column chart for GPM% and YOY% by month
STEP 1 – Copy and paste the previous visual. Click on it and Go
to visualization, Click on Line and Clustered Column Chart
STEP 2- Remove all the field, Drag and drop Gross Profit Margin
% in the Column values, YOY % in line values and Month in the share axis from
the date hierarchy.
STEP 3 - Go to formatting and change the title to GPM% by Month
Follow the GIF below to apply the above steps
STEP 4- Go to X Axis. Font color = black, text size 9, font
family = Arial black and turn the title off
STEP 5- Go to y Axis. Font color = black, text size 9, font
family = Arial black and turn the title off, turn on show secondary line and make
the same font with the first line
Follow the GIF below to apply the above steps
STEP 6 – Go to Legend and make the color= black, text
size=12, font family= Din
STEP 7- Turn on data label, change the color = black,
decimal place =1, show background off, turn on customize serious and change it
to YOY%. Color = #8d6fd1, decimal place=1, text size= 9, font family = Arial black, Show background off
Follow the GIF below to apply the above steps
STEP 8– Click Data on data color YOY% = color #2e1039, for the default =color #71afe2
STEP 9-
Click on shape and turn on the shade area
STEP 10 – Go to y Axis and change the secondary line
to color=# #8d6fd1
Follow
the GIF below to apply the above steps
How to create line and clustered column chart